UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ez9KTmHQ1SbAdzkURwLV1hdoAYLWcw9N+wltsiEOPI='
WHERE
key_id = '732311730f4f1ad13cca58fbe9b579614d54521939ea5b1fa169d91186a496bb'
AND (
token = '0ez9KTmHQ1SbAdzkURwLV1hdoAYLWcw9N+wltsiEOPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)