UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'msZH9dyPGp/Q1lubb1j6CTXPsCkdFaiOgZFCuUM+Jww='
WHERE
key_id = 'f197625f880cf47036b6aeb6fa998794df8ee4d48d207be30f04e15e1856b24c'
AND (
token = 'msZH9dyPGp/Q1lubb1j6CTXPsCkdFaiOgZFCuUM+Jww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)