UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjiLiZE6/hbGk79JL7ycUYB9V6+Yi7qLXWR58KtC5gs='
WHERE
key_id = '3bc432bdadbee2a709752f57aae223dd2e6b4038dc4606d901d78d9d30508da0'
AND (
token = 'ZjiLiZE6/hbGk79JL7ycUYB9V6+Yi7qLXWR58KtC5gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)