UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8QhBDecBwQHZkgi3jt+xfkcOndDE9bEz+xl4rFshZn8='
WHERE
key_id = '3ab87e55cec406c0276a4246d6ab410af1146b7860abc358da5c883921f2b9d3'
AND (
token = '8QhBDecBwQHZkgi3jt+xfkcOndDE9bEz+xl4rFshZn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)