UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQq/7c2oo8idCOXWnNYvtv4UFVneLPwjO9DntOOJbHA='
WHERE
key_id = 'a9e89d69a0d66675f29571132e9d151cf9592bc5948a237164af6f87b9fe0c0e'
AND (
token = 'HQq/7c2oo8idCOXWnNYvtv4UFVneLPwjO9DntOOJbHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)