UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0vrswL0FOcMiZLeBhFvoQC6KxsLetYBWxO9VYsVjk8g='
WHERE
key_id = 'a99a1932cefa873685418b59979323433affdc0a06a78e0a3f2bf67a3fd2a5ba'
AND (
token = '0vrswL0FOcMiZLeBhFvoQC6KxsLetYBWxO9VYsVjk8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)