UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'H4mCy5WDaesB+15/u0l1xTijtmtyiJIKNEdwFxbh/MA=' 
WHERE 
  key_id = '6fe4733bea5fd4ea8f7d6d9a59a93f29073c4d3a33e34a6e72e030e9eadb4137' 
  AND (
    token = 'H4mCy5WDaesB+15/u0l1xTijtmtyiJIKNEdwFxbh/MA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032