UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QFP1b48X9Hii50M7SSH10v288/qLGJa0z/KtuIUG3aU=' 
WHERE 
  key_id = '2c1663f5edb291c0852b8dd2c5142b9839b46b7572c208cc607239e5e04fb555' 
  AND (
    token = 'QFP1b48X9Hii50M7SSH10v288/qLGJa0z/KtuIUG3aU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044