UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b6s6AeFNi+9y4lGH4VccVTss//4PMVZR92XKmykmc+E='
WHERE
key_id = '01e78335a400534d5f0359464762dd84d3b9909637063d0889d6acd4392e6b27'
AND (
token = 'b6s6AeFNi+9y4lGH4VccVTss//4PMVZR92XKmykmc+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)