UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xkTGwGs6xig/+ciD3sK2/k3XJoAdXQgxxQrsM211rag='
WHERE
key_id = 'f01defaad5321055b3ee918cf40e727cf52243064e8a3f4ef8ad97958116f55d'
AND (
token = 'xkTGwGs6xig/+ciD3sK2/k3XJoAdXQgxxQrsM211rag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)