UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KHXiweRibiEUUSWOq4fsR8hTGJN2Hx8XiictuyhzfDE='
WHERE
key_id = 'a3ad0af016530e5ebd6c78282de4f6ec070e6b82be06aa18c6e2ebf88fc1e698'
AND (
token = 'KHXiweRibiEUUSWOq4fsR8hTGJN2Hx8XiictuyhzfDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)