UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/BoL1Uge2RUKijZkUa6JtW10LaZJOwNV/+KaIqkPwL0=' 
WHERE 
  key_id = '8e30dd04f3780f9ca62822b7f387a2f018153cd8be9eed9e3fc60dbedc2c7b2c' 
  AND (
    token = '/BoL1Uge2RUKijZkUa6JtW10LaZJOwNV/+KaIqkPwL0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027