UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'No6wSyw4tBfaZmjRKG8L2/5dbz3IB1Le6aVHR161pJU='
WHERE
key_id = 'c6497272eb97c14453dafaed299cc4c9339309583bf6026a2235e33640f97ebd'
AND (
token = 'No6wSyw4tBfaZmjRKG8L2/5dbz3IB1Le6aVHR161pJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)