UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7cXRpaeGRdQkxnOHHVxGhRDet6hrTgsBTp3lcM3wDls='
WHERE
key_id = 'e7c1f4600e7bf92c999dead57b680698504ef02454d9273433be47c1d71a3a3e'
AND (
token = '7cXRpaeGRdQkxnOHHVxGhRDet6hrTgsBTp3lcM3wDls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)