UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yx82iCu4fKkOwtJek1G4yfjiwfRwuN5tUMKym3b/pw0='
WHERE
key_id = '1b3d10f5473d848c99186ae97b9883362fb66f3a86d31238cde7d25ec9188f23'
AND (
token = 'yx82iCu4fKkOwtJek1G4yfjiwfRwuN5tUMKym3b/pw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)