UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ahSbvbd6S+TUahWJrsCiu8hK4oM5N9PgmllEmBBCuuo=' 
WHERE 
  key_id = '5e25adcca00f52c96653d072ca2de70ad8cf7cefc8afebe7389117d6d7dcebd3' 
  AND (
    token = 'ahSbvbd6S+TUahWJrsCiu8hK4oM5N9PgmllEmBBCuuo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028