UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QBhYh8dpj7guc8yuEmFk5RyZLr3Z4yPpcG9MnAifnOc='
WHERE
key_id = 'bc876b602e601ac295f4c4c570c6bfb53155a9001717e14816c5fc1127ef507e'
AND (
token = 'QBhYh8dpj7guc8yuEmFk5RyZLr3Z4yPpcG9MnAifnOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)