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