UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yTiNWE2+odtc8rC8esLHIz7j6M7MGL2dTAb+2fny/Lg=' 
WHERE 
  key_id = '448c7a67903363273a9ebf66aef2dac2c35ee555e6b3d9105ce90324c12c6101' 
  AND (
    token = 'yTiNWE2+odtc8rC8esLHIz7j6M7MGL2dTAb+2fny/Lg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030