UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4r9gLWxOei1Iyel6uAbOgG7Ifsbcwe8JJocoOlLvYo='
WHERE
key_id = 'e750961aa0b698162bb3c158ef408af092d850e768b5f4c2e1108e59ca5447f1'
AND (
token = 'z4r9gLWxOei1Iyel6uAbOgG7Ifsbcwe8JJocoOlLvYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)