UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fi9xCR7MH+j5QOeXUU0zwwAHrt8hahj0fGFkZEKxXAg='
WHERE
key_id = 'cc763cb10cb468f374bb54b4642771a7b0d83f90f435ce826290536280964a3d'
AND (
token = 'fi9xCR7MH+j5QOeXUU0zwwAHrt8hahj0fGFkZEKxXAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)