UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFCLr7p7Kv7OTYKVDMsbTDwaEaQ7jxoFSO7FhgX0y30='
WHERE
key_id = '54fcf05f80a9416a7491bdc9de5f03f7ae4105c5c0f595190c0dfe82d5d6f2e8'
AND (
token = 'ZFCLr7p7Kv7OTYKVDMsbTDwaEaQ7jxoFSO7FhgX0y30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)