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