UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKIU1gGGyEZL87U38qeXOT8+Do1ViVZPcRcMOF+6opU='
WHERE
key_id = '4564da7d47024aa61377ee7f760031826d534a047ea9be4faba708bab6f58d0a'
AND (
token = 'nKIU1gGGyEZL87U38qeXOT8+Do1ViVZPcRcMOF+6opU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)