UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgx4xnkNVpg58zW6AtMHTbJZ0epO60d4X8h9c2gzIF4='
WHERE
key_id = 'e82d778636faedb30b2387d43c0f454fd0277134e3a8a09765cd059403a4f5f6'
AND (
token = 'xgx4xnkNVpg58zW6AtMHTbJZ0epO60d4X8h9c2gzIF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)