UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+UNPbv4Iy98npgvZCDy0ledSq4WNh6qOKReccxLaPms=' 
WHERE 
  key_id = '8a0566b2f2fd899b472584dbc99dd95fb405dec63854892319403036e0a8b93e' 
  AND (
    token = '+UNPbv4Iy98npgvZCDy0ledSq4WNh6qOKReccxLaPms=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039