UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e0VFyzFk2yLnv40D6nG1Q+xug0BiVBxHry/R/7KbJRo='
WHERE
key_id = '9bd0396921d8fc65d10bc7c6cc05c4fee2e5bfd3236df9c2a9584abf9065eaff'
AND (
token = 'e0VFyzFk2yLnv40D6nG1Q+xug0BiVBxHry/R/7KbJRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)