UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eiKGmydOiNV9UEqQvEnHZFJjCcQpBAgMtpLfQa3Sbqo='
WHERE
key_id = '175b4aca42aff4980fb276416d793a605470f547338ed03c7e7ec44af3686a25'
AND (
token = 'eiKGmydOiNV9UEqQvEnHZFJjCcQpBAgMtpLfQa3Sbqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)