UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/UxPvLjKVgB+z7mFzymtE/BTShbs5EcbQyy8qxWjhSY='
WHERE
key_id = 'c3ecf0e716911a3a9f9bcd88f61c32e1f62485b0c12d0273456fc9ef5653faa3'
AND (
token = '/UxPvLjKVgB+z7mFzymtE/BTShbs5EcbQyy8qxWjhSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)