UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9KoO9dYr44FnocI0Lghm4J5ynF14Q2G2c7fVpLvwVL4=' 
WHERE 
  key_id = 'a95c93185110ca1e2f6e265fc6fd20f4b49f9b21d3f11099c9e0478bc20c4cb4' 
  AND (
    token = '9KoO9dYr44FnocI0Lghm4J5ynF14Q2G2c7fVpLvwVL4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034