UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/7fQ+6fVAelt931fHXBXW/zc8L8prxqbB6k13P1p6mU=' 
WHERE 
  key_id = '8ea110f2f78b0aa54040adabdd9aea5af15044ea3cb503912f2bc2730c94671a' 
  AND (
    token = '/7fQ+6fVAelt931fHXBXW/zc8L8prxqbB6k13P1p6mU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030