UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RxtXe02Bw+KKYx7CirC1/n4ESZvVNJTuFnbuy/10lGw=' 
WHERE 
  key_id = 'a2f0d0b2e2d192fff9952e0aea5a483e4c38a3e9429eb9fa0089215d79437434' 
  AND (
    token = 'RxtXe02Bw+KKYx7CirC1/n4ESZvVNJTuFnbuy/10lGw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022