UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b/gyrSW0lgw/8XEOgQYOwLmhA64RUXuEE407fi0itwY='
WHERE
key_id = '8bbd9224bea21b67885eef989c088935e00166620396458aeabb8662cd67aa83'
AND (
token = 'b/gyrSW0lgw/8XEOgQYOwLmhA64RUXuEE407fi0itwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)