UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TGIMYnFn00N3vWlPttn2P7zhY+PCXZGDIgl2HXiDbPg=' 
WHERE 
  key_id = '1aa49714c0db5f839ce9ec432c75c1e02b1d35c91af2f60d6f152d3712de7687' 
  AND (
    token = 'TGIMYnFn00N3vWlPttn2P7zhY+PCXZGDIgl2HXiDbPg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038