UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6x9plSvP28leOYrPjOjCRYC5DgFHtxiyUMIPQVaUpp8='
WHERE
key_id = '98577c27db5b67eb0365c60fc7c554426e66924ee3415e1c772bfb6ff4fec9b9'
AND (
token = '6x9plSvP28leOYrPjOjCRYC5DgFHtxiyUMIPQVaUpp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)