UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G+l1ar+V4tM5PdQjf0hQdHv+rCERYqtXiM05aaNUJxM='
WHERE
key_id = 'caa686d6c34bd42e8f9a4c6fe2b060a3b9aa1b96d7a6e525b7b5c34202c9a55f'
AND (
token = 'G+l1ar+V4tM5PdQjf0hQdHv+rCERYqtXiM05aaNUJxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)