UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COGWwUixWZE+LIH6UeDwAh2EEulxhiTY9BjqQlYz7z0='
WHERE
key_id = 'a810dbb5c514dc43d1e8ef24f8cf13f2eeeff59b13ec733d755bfdef3ee17d4d'
AND (
token = 'COGWwUixWZE+LIH6UeDwAh2EEulxhiTY9BjqQlYz7z0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)