UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'War8Ns6YrjoH1zyUHANF3Mes1ypNW2OkZo5Cl+BnM5M=' 
WHERE 
  key_id = '8b1b3a6dfbebab4725e95a3c87ecdb0dd90cfdf7f42560b9406623a3889960f2' 
  AND (
    token = 'War8Ns6YrjoH1zyUHANF3Mes1ypNW2OkZo5Cl+BnM5M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034