UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zcHK2ThEHPy9tSzTcjxzCFbA9JlqQdi/YhI8vK+X/Dc=' 
WHERE 
  key_id = 'dace9068cb332d2873cf09003b427f1ea8f14bdf29e3589bbda7279d01bb4abf' 
  AND (
    token = 'zcHK2ThEHPy9tSzTcjxzCFbA9JlqQdi/YhI8vK+X/Dc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037