UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sRF+PTGhl34DMU+ycs7wSwQEZf6KHDF8q1uQkM2OtxQ='
WHERE
key_id = '9c9c740d346bdb5c1dc63840123da293ec5a05c819589935d91d4f2accce1d2a'
AND (
token = 'sRF+PTGhl34DMU+ycs7wSwQEZf6KHDF8q1uQkM2OtxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)