UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x2JCWdwGm8w8DOS6h2ggnCglMyArGTM45nCh30bTX0Y='
WHERE
key_id = '823e742c038d34d7c93a52e3d2dd6bd81a17920c9bd29e29fad646ff861d397d'
AND (
token = 'x2JCWdwGm8w8DOS6h2ggnCglMyArGTM45nCh30bTX0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)